Item Master (IV00101)

azurecurveProductsMicrosoft Dynamics GP (0)InventoryItem Master (IV00101)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00101

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Item Master
Physical Name: IV00101
Technical Name: IV_Item_MSTR

Group Display Name: Item Master
Group Technical Name: Item Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
2ITEMDESC SearchItem DescriptionStringSTR100100
3NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Item Master'].NOTEINDX AS 'Item Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Item Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4ITMSHNAM SearchItem Short NameStringSTR1515
5ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
6ITMGEDSC SearchItem Generic DescriptionStringSTR1010
7STNDCOST SearchStandard CostCurrencyDLR17_RBS0_UTR$17
8CURRCOST SearchCurrent CostCurrencyDLR17_RBS0_UTR$17
9ITEMSHWT SearchItem Shipping WeightLong IntegerLI6_RBS2_UT6
10DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
11DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
12ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Item Master'].ITMTSHID AS 'Item Master-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Master'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
13TAXOPTNS SearchTax OptionsIntegerDDL_Tax_Options0
14IVIVINDX SearchIV IV IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVIVINDX AS 'Item Master-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVIVINDX = ['Account Index Master'].ACTINDX
15IVIVOFIX SearchIV IV Offset IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVIVOFIX AS 'Item Master-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVIVOFIX = ['Account Index Master'].ACTINDX
16IVCOGSIX SearchIV COGS IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVCOGSIX AS 'Item Master-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVCOGSIX = ['Account Index Master'].ACTINDX
17IVSLSIDX SearchIV Sales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVSLSIDX AS 'Item Master-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVSLSIDX = ['Account Index Master'].ACTINDX
18IVSLDSIX SearchIV Sales Discounts IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVSLDSIX AS 'Item Master-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVSLDSIX = ['Account Index Master'].ACTINDX
19IVSLRNIX SearchIV Sales Returns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVSLRNIX AS 'Item Master-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVSLRNIX = ['Account Index Master'].ACTINDX
20IVINUSIX SearchIV In Use IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVINUSIX AS 'Item Master-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVINUSIX = ['Account Index Master'].ACTINDX
21IVINSVIX SearchIV In Service IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVINSVIX AS 'Item Master-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVINSVIX = ['Account Index Master'].ACTINDX
22IVDMGIDX SearchIV Damaged IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVDMGIDX AS 'Item Master-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVDMGIDX = ['Account Index Master'].ACTINDX
23IVVARIDX SearchIV Variances IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVVARIDX AS 'Item Master-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVVARIDX = ['Account Index Master'].ACTINDX
24DPSHPIDX SearchDrop Ship IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].DPSHPIDX AS 'Item Master-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].DPSHPIDX = ['Account Index Master'].ACTINDX
25PURPVIDX SearchPurchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].PURPVIDX AS 'Item Master-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].PURPVIDX = ['Account Index Master'].ACTINDX
26UPPVIDX SearchUnrealized Purchase Price Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].UPPVIDX AS 'Item Master-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].UPPVIDX = ['Account Index Master'].ACTINDX
27IVRETIDX SearchInventory Returns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVRETIDX AS 'Item Master-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVRETIDX = ['Account Index Master'].ACTINDX
28ASMVRIDX SearchAssembly Variance IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].ASMVRIDX AS 'Item Master-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].ASMVRIDX = ['Account Index Master'].ACTINDX
29ITMCLSCD SearchItem Class CodeStringSTR10_Class_ID10
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['Item Master'].ITMCLSCD AS 'Item Master-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['Item Master'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
30ITMTRKOP SearchItem Tracking OptionIntegerDDL_Track0
Designation for the tracking type of the Item.

Click to show/hide Item Tracking Options

1	0 decimals
2	1
3	2
4	3
5	4
6	5
31LOTTYPE SearchLot TypeStringSTR10_Lot_Type10
32KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
33KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
34KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
35KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
36ALWBKORD SearchAllow Back OrdersBooleanCB_Allow_Back_Orders0
37VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
The valuation method for the inventory line item.

Click to show/hide Valuation methods

1	FIFO Perpetual
2	LIFO Perpetual
3	Average Perpetual
4	FIFO Periodic
5	LIFO Periodic
38UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['Item Master'].UOMSCHDL AS 'Item Master-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['Item Master'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
39ALTITEM1 SearchAlternate Item 1StringSTR30_Item_Number30
40ALTITEM2 SearchAlternate Item 2StringSTR30_Item_Number30
41USCATVLS_1 SearchUser Category Values[1]StringUser_Category_Value10
42USCATVLS SearchUser Category ValuesUser_Category_ValueString10
43USCATVLS_2 SearchUser Category Values[2]StringUser_Category_Value10
44USCATVLS_3 SearchUser Category Values[3]StringUser_Category_Value10
45USCATVLS_4 SearchUser Category Values[4]StringUser_Category_Value10
46USCATVLS_5 SearchUser Category Values[5]StringUser_Category_Value10
47USCATVLS_6 SearchUser Category Values[6]StringUser_Category_Value10
48MSTRCDTY SearchMaster Record TypeIntegerINT11
49MODIFDT SearchModified DateDateDT8
50CREATDDT SearchCreated DateDateDT8
51WRNTYDYS SearchWarranty DaysIntegerINT44
52PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
53LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Item Master'].LOCNCODE AS 'Item Master-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Item Master'].LOCNCODE = ['Site Setup'].LOCNCODE
54PINFLIDX SearchPurch Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].PINFLIDX AS 'Item Master-Purch Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].PINFLIDX = ['Account Index Master'].ACTINDX
55PURMCIDX SearchPurch Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].PURMCIDX AS 'Item Master-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].PURMCIDX = ['Account Index Master'].ACTINDX
56IVINFIDX SearchInventory Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVINFIDX AS 'Item Master-Inventory Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVINFIDX = ['Account Index Master'].ACTINDX
57INVMCIDX SearchInventory Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].INVMCIDX AS 'Item Master-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].INVMCIDX = ['Account Index Master'].ACTINDX
58CGSINFLX SearchCOGS Inflation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].CGSINFLX AS 'Item Master-COGS Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].CGSINFLX = ['Account Index Master'].ACTINDX
59CGSMCIDX SearchCOGS Monetary Correction IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].CGSMCIDX AS 'Item Master-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].CGSMCIDX = ['Account Index Master'].ACTINDX
60ITEMCODE SearchItem CodeStringSTR1515
61TCC SearchTax Commodity CodeStringSTR30_VAT30
62PriceGroup SearchPrice GroupStringSTR10_LBAU10
63PRICMTHD SearchPrice MethodIntegerDDL_Price_Method0
64PRCHSUOM SearchPurchasing U Of MStringU_Of_M8
65SELNGUOM SearchSelling U Of MStringU_Of_M8
66KTACCTSR SearchKit COGS Account SourceIntegerGB0
67LASTGENSN SearchLast Generated Serial NumberStringSTR20_LBAU20
68ABCCODE SearchABC CodeIntegerDDL_ABC_Code0
69Revalue_Inventory SearchRevalue InventoryBooleanCB_Revalue_Inventory0
70Tolerance_Percentage SearchTolerance PercentageLong IntegerLI7_U%37
71Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Item Master'].Purchase_Item_Tax_Schedu AS 'Item Master-Purchase Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Item Master'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
72Purchase_Tax_Options SearchPurchase Tax OptionsIntegerDDL_Purchase_Tax_Options0
73ITMPLNNNGTYP SearchItem Planning TypeIntegerDDL_Item_Planning_Type0
74STTSTCLVLPRCNTG SearchStatistical Value PercentageIntegerINT4_%24
75CNTRYORGN SearchCountry OriginStringSTR6_VAT6
76INACTIVE SearchInactiveBooleanCB_Inactive0
77MINSHELF1 SearchMinShelfLife1IntegerINT4_U04
78MINSHELF2 SearchMinShelfLife2IntegerINT4_U04
79INCLUDEINDP SearchInclude in Demand PlanningBooleanCB_IncludeInDemandPlanning0
80LOTEXPWARN SearchLot Expire WarningBooleanCB_Lot_Expire_Warning0
81LOTEXPWARNDAYS SearchLot Expire Warning DaysIntegerINT3_RB0_U3
82LASTGENLOT SearchLast Generated Lot NumberStringSTR20_LBAU20
83Lot_Split_Quantity SearchLot Split QuantityCurrencyDLR17_QTY_RBS0_UTR17
84UseQtyOverageTolerance SearchUse Qty Overage ToleranceBooleanCB0
85UseQtyShortageTolerance SearchUse Qty Shortage ToleranceBooleanCB0
86QtyOverTolerancePercent SearchQty Overage Tolerance PercentageLong IntegerLI5_%35
87QtyShortTolerancePercent SearchQty Shortage Tolerance PercentageLong IntegerLI5_%35
88IVSCRVIX SearchIV STD Cost Revaluation IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Item Master'].IVSCRVIX AS 'Item Master-IV STD Cost Revaluation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Item Master'].IVSCRVIX = ['Account Index Master'].ACTINDX
89USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Item Master'].USERID AS 'Item Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       IV00101 AS ['Item Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Item Master'].USERID = ['Users Master'].USERID
azurecurveProductsMicrosoft Dynamics GP (0)InventoryItem Master (IV00101)

2 thoughts on “Item Master (IV00101)”

  1. Hussain Al Yousef says:
    23rd June 2022 at 0701

    ITEMTYPE = Item Types:
    1 – Sales Inventory
    2 – Discontinued
    3 – Kit
    4 – Misc Charges
    5 – Services
    6 – Flat Fee

    Reply
    1. iangrieve says:
      23rd June 2022 at 0803

      Thanks for contributing this.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *